Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy
Jobs / Job page
[Data Engineer] Staff Database Administrator (PostgreSQL – Performance Tuning Expert Expert) image - Rise Careers
Job details

[Data Engineer] Staff Database Administrator (PostgreSQL – Performance Tuning Expert Expert)

Data Engineering Team New York City, NY Boston, MA Hybrid Schedule (M/F remote, T/W/TH in-office) At Magnite, we cultivate an environment of continuous growth and collaboration. Our work impacts what millions of people read, watch, and buy, and we’re looking for people to help us tackle that responsibility with creativity and focus. Magnite (NASDAQ: MGNI) is the world’s largest independent sell-side advertising platform. Publishers use our technology to monetize their content across all screens and formats including CTV / streaming, online video, display, and audio. Our tech fuels billions of transactions per day!Magnite conducts 400+ billion ad request auctions daily carrying $450+ million of revenue annually. To stand out among competitors, Magnite strategically focuses on being the most efficient, highest scale independent exchange.The TeamThe Streaming Organization's Data Engineering team owns the applications and infrastructure that make up the Streaming Org's data pipeline, handling ~40 billion events per day at an average of 400-500 thousand per second. This data underpins the Streaming business - including client reporting, internal data science, account managers, and product + business teams - and as such we need to build systems that remain scalable and efficient at this volume of data while also ensuring data consistency and reliability. We value communication, discussion, and sharing of ideas to come to the best technical solutions to our large-scale data challenges. We are looking for people who want to get things done and value open collaboration (including constructive feedback when brainstorming). Our end-to-end ownership of the data world includes both typical data-engineering type problems (think Spark pipelines, ETL processing, etc) and more general software-engineering tech as well (think Java applications, API design, etc).In This Role You Will• Get to work on handling internet-scale data problems• Help architect and build systems to process our data volume to empower all consumers• Join in on full end-to-end ownership of the team's data pipeline and related systems for data delivery• Be a part of and promote our culture of collaboration and mentorshipTypical Challenges We Face In This Role Include• Highly-scalable infrastructure: Our traffic has patterns with peak- and off-peak times and seasonal shifts, and our data infrastructure needs to be able to respond accordingly• Cost optimization: Improving profit margins by lowering the infrastructure cost basis through building efficient systems• Technical architecture considerations given various SLAs for data deliveryWe’re Looking For Someone• With 4+ years of software development experience with a BS/MS Computer Science or equivalent work experience• Who wants to take ownership. We are responsible for the entire software development lifecycle, from requirements gathering to production support• To engage in critical and creative thinking. We expect engineers to present and discuss tradeoffs to solve the problems we face• With either existing experience designing and building systems that work with large-scale data volumes and data ingestion systems at scale in a cloud-first setting, OR established technical excellence with a desire to learn and crush the data engineering worldOur Current Tech Stack• Java for core application development• Spark (batch + streaming) for data pipeline development, currently based on Databricks• Terraform, Docker, Jenkins for CI/CD / infra / application deployment• Airflow for job orchestration• AWS-based cloud infrastructure including RDS, EC2, S3, Kinesis, ECSTotal Rewards IncludeComprehensive Perks And Benefits• Comprehensive Healthcare Coverage for You and Your Family from Day One• Generous Time Off• Holiday Breaks, Summer Fridays and Quarterly Wellness Days• Equity and Employee Stock Purchase Plan• Family-Focused Benefits and Parental Leave• 401k Retirement Savings Plan with Employer Match• Disability and Life Insurance• Cell Phone Subsidy• Fitness and Wellness ReimbursementCompany CultureWe believe collaboration is essential to success. Our offices provide catered lunches, beverages, snacks, training and development, and office events to support your work week. We also understand you have appointments, families, hobbies, and other commitments. Magnite strives to maintain a healthy work/life integration for all employees so you can bring your best every day - both at work and at home.• Community Service and Volunteer Events• Company-Matched Charitable Contributions• Wellness Coach and Mental Health SupportMagnite Invests In You• Career Development Initiatives and a Career Growth Framework• Culture and Inclusion Programs• Bonusly Peer-to-Peer Recognition ProgramA Little More About UsThe world's leading agencies and brands trust our platform to access brand-safe, high-quality ad inventory and execute billions of advertising transactions each month. Anchored in bustling New York City, sunny Los Angeles, mile high Denver, historic London, and down under in Sydney, Magnite has offices across North America, EMEA, LATAM, and APAC.In New York, the base salary range for this position, depending on the level is: $150,000 - $170,000 in addition to an annual variable bonus based on performance and company equity (NASDAQ: MGNI).In Massachusetts, the base salary range for this position, depending on the level is: $150,000 - $170,000 in addition to an annual variable bonus based on performance and company equity (NASDAQ: MGNI).Magnite is an Equal Opportunity Employer and does not discriminate against applicants due to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, sexual orientation or any other federal, state or local protected class.Our DEI Commitment: To establish Magnite as a thought leader by diversifying voices within Magnite, cultivating a culture in which employees feel safe as their authentic selves, and by investing in strategies to support Magnite’s local communities.Want to learn more about us?Check out our blog for Magnite announcements and Ad Tech industry news!

Average salary estimate

Estimate provided by employer
$97500 / ANNUAL (est.)
min
max
$80K
$115K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About [Data Engineer] Staff Database Administrator (PostgreSQL – Performance Tuning Expert Expert), Agoda

Are you ready to take your career to the next level as a Staff Database Administrator (PostgreSQL – Performance Tuning Expert) at Magnite? Based in sunny San Diego, CA, you'll be joining a forward-thinking team that thrives on collaboration and innovation. At Magnite, we are the world’s largest independent sell-side advertising platform, and we work hard to ensure that publishers can monetize their content across a variety of screens and formats. You will be tackling internet-scale data challenges daily, managing a massive flow of data that supports our streaming, client reporting, and internal analytics services. With your passion for problem-solving and your expertise in performance tuning and database management, you will be playing a vital role in enhancing our data pipelines and ensuring the integrity and efficiency of our data handling. You won't just be writing code; instead, you will be building systems that are crucial for the company’s operations, interfacing directly with our engineering and product teams to drive impactful results. We value creativity and critical thinking in our workplace, so you can expect to engage in meaningful discussions and mentorship from your peers, ensuring that you are constantly learning and sharing knowledge. If you're excited about optimizing large-scale data environments and contributing to a culture that prioritizes collaboration and growth, Magnite is the perfect place for you to shine.

Frequently Asked Questions (FAQs) for [Data Engineer] Staff Database Administrator (PostgreSQL – Performance Tuning Expert Expert) Role at Agoda
What are the main responsibilities of a Staff Database Administrator at Magnite?

As a Staff Database Administrator (PostgreSQL – Performance Tuning Expert) at Magnite, your primary responsibilities will include managing and optimizing our PostgreSQL databases to ensure efficient data handling and delivery. You will also work on architecting systems that can handle the vast amounts of data generated by our platform while ensuring data consistency and reliability. Additionally, you will engage in performance tuning initiatives and collaborate closely with software development teams to implement best practices in database management.

Join Rise to see the full answer
What skills are required for a Data Engineer at Magnite?

To excel as a Staff Database Administrator at Magnite, candidates must possess a strong foundation in software development, preferably with 4+ years of experience. Key skills include proficiency in PostgreSQL performance tuning, data ingestion systems, and experience with Java application development. Familiarity with cloud infrastructure such as AWS and data processing frameworks like Spark is essential. Your engagement in critical thinking and problem-solving will be crucial for navigating the complexities of our data systems.

Join Rise to see the full answer
How does Magnite support career growth for its Data Engineering team?

Magnite is committed to the professional growth of its employees, including those in the Data Engineering team. As a Staff Database Administrator, you will have access to various career development initiatives and a structured career growth framework. Continuous learning is encouraged through mentorship, peer recognition programs, and training opportunities, enabling you to enhance your skills and advance in your career while contributing to the organization.

Join Rise to see the full answer
What programming languages and technologies are primarily used at Magnite?

At Magnite, the technology stack is diverse and designed for scalability and efficiency. As a Staff Database Administrator (PostgreSQL – Performance Tuning Expert), you will primarily work with Java for core application development, alongside Spark for data processing. Familiarity with tools such as Terraform, Docker, and Airflow for infrastructure management and job orchestration is also pivotal to your role. This range of technologies will provide you with a dynamic foundation for data engineering challenges.

Join Rise to see the full answer
What makes the work culture at Magnite unique for Data Engineers?

The work culture at Magnite is centered around collaboration, innovation, and mutual growth. As a Staff Database Administrator, you will be part of a team that encourages open communication and shared ideas, allowing for constructive feedback and brainstorming sessions. Additionally, Magnite values work/life balance, offering flexibility and a supportive environment where employees are encouraged to be their authentic selves while excelling in their work.

Join Rise to see the full answer
Common Interview Questions for [Data Engineer] Staff Database Administrator (PostgreSQL – Performance Tuning Expert Expert)
Can you explain your experience with PostgreSQL and performance tuning?

When answering this question, highlight specific projects where you successfully optimized PostgreSQL databases. Describe the strategies you used, such as indexing, query optimization, and configuration adjustments. Provide measurable outcomes where possible, such as efficiency gains or improved response times.

Join Rise to see the full answer
What challenges have you faced while working with large-scale data environments?

Discuss a specific challenge you encountered, such as managing peak traffic loads or ensuring data consistency. Explain how you approached these challenges, the technologies you employed, and what the outcomes were—focusing on the skills that align with the role at Magnite.

Join Rise to see the full answer
How do you approach database security and data integrity?

Talk about the security measures you've implemented in past projects, including encryption, access controls, and regular audits. Demonstrate your understanding of data integrity principles and how maintaining accurate data is crucial for business operations, particularly in an advertising context like Magnite.

Join Rise to see the full answer
Can you describe your experience with cloud infrastructure, particularly AWS?

Share your experiences with AWS components like RDS, EC2, or S3. Highlight how you utilized these services for database management and data processing, and touch upon any challenges and lessons learned that could apply to Magnite's cloud-first approach.

Join Rise to see the full answer
What strategies do you use for effective collaboration within a team?

Emphasize your communication skills and the importance of sharing knowledge among team members. Discuss methods such as regular meetings, code reviews, and collaborative tools that foster an inclusive environment where everyone's contributions are valued, aligning with Magnite's work culture.

Join Rise to see the full answer
How do you stay updated on new database technologies and industry trends?

Describe how you actively pursue professional development, whether through online courses, attending workshops, or participating in tech communities. Mention relevant resources such as blogs, podcasts, or webinars that keep you informed about innovations in data engineering.

Join Rise to see the full answer
How would you handle a performance issue in a production database?

Illustrate your troubleshooting process: start by identifying the symptoms, then analyze query performance and metrics before implementing solutions. Mention any tools or techniques you would apply to monitor and resolve performance bottlenecks in real time.

Join Rise to see the full answer
Explain your experience with ETL processes.

Provide specifics on ETL tools or frameworks you have utilized and detail how you managed data extraction from various sources, performed transformations, and loaded data into destination systems. Highlight the importance of clean and reliable data flow in supporting data-driven decisions.

Join Rise to see the full answer
What would you consider best practices for database maintenance?

Share a set of best practices including regular backups, updates, performance tuning checks, and monitoring. Emphasize your ongoing commitment to maintaining optimal database health, which aligns with Magnite's data reliability goals.

Join Rise to see the full answer
Why do you want to work at Magnite?

Express your enthusiasm for the innovative work Magnite is doing in the advertising technology space. Tie your personal and professional goals to the company culture of collaboration and the focus on large-scale data challenges, showing that you're motivated to contribute actively to the team.

Join Rise to see the full answer

Managing a system this complex requires a passion for technology. In offices from Bangkok to New York and dozens of places in between, our talented people work hard every day to find solutions, create value, and push boundaries.

43 jobs
MATCH
Calculating your matching score...
FUNDING
DEPARTMENTS
SENIORITY LEVEL REQUIREMENT
TEAM SIZE
EMPLOYMENT TYPE
Full-time, hybrid
DATE POSTED
December 11, 2024

Subscribe to Rise newsletter

Risa star 🔮 Hi, I'm Risa! Your AI
Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!